1: the EnvironmentServer environment:Machine Name: ZEHUADB (MSSQL)Operating system: Windows ServerDatabase version: SQL Server SP4 Personal Edition
ClientMachine Name: ZLP (DANDAN)Operating system: Windows XPDatabase version: SQL Server SP4
Error message:
Title: Unable to connect to the server
------------------------------cannot connect to
(local).
------------------------------
Additional information: a
network-related or instance-specific error occurred while
Js|server First step:----Install J2SDK:
Download J2SDK installation files to the Sun official site (http://java.sun.com): j2sdk-1_4_2_04- Windows-i586-p.exe, download and install the J2SDK after installation, set environment variables: My Computer---
server| error three most common errors in SQL Server connections:
One. " SQL Server does not exist or access is denied "
This is the most complex, the cause of the error is more, need to check the aspect also more.
Generally speaking, there are
server| Server | Solution for remote Connection SQL Server 2000 Server
A look at ping server IP can ping through.
This actually looks at whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network to see
The same problem was found in the installation of the application system for all the cooperative schools, when the SQL Server 2000 database in the school was damaged, and the installation of the SQL Server database was unsuccessful. Reason: Even if
Data | database
How to FIX SQL Server DATABASE suspect?
How do I fix the database state "suspect"?
**********************************************************
Author: Huangshan Bright Top
Mail:leimin@jxfw.com
version:1.0.0
Date:2004-1-30
(If
second, "Unable to connect to the server, the user XXX login failed"
(Figure 5)
This error occurs because SQL Server uses Windows only authentication, so users cannot connect using SQL Server's logon account, such as SA. The workaround looks
After installing MS SQL Server 2005, it's not a good habit. Because you've been using SQL Server 2000 before, you've found that SQL Server 2005 has been changed in many places, sometimes with a little bit of functionality. It's not the first time
1. Start or stop the SQL Agent service in Query Analyzer
Start
Use master
Go
xp_cmdshell ' net start SQLServerAgent '
Stop it
Use masterGoxp_cmdshell ' net stop SQLServerAgent '
Change the startup of a service from manual to automatic startexec xp_
1. When you start the SQL Server Agent (MSSQLSERVER) service, a window appears as shown in the picture.
2. Right-click the Agent service and choose Properties to open the Properties dialog box.
3, switch to the
The following are only references, and may be slightly different if there are multiple instances:
This environment is SQL Server Standard version 64-bit and SQL Server 2008 Standard version 64-bit dual instances installed simultaneously in a
On
/*
Note: If the value returned by the query path is NULL, the default installation path is
C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data
*/
--Query User library data file default path:
DECLARE @DefaultData VARCHAR (100)
server| problem
After discovering the GLOBAL.ASA+.HTR bug, the ID and password of the SQL Server database are often exposed to our eyes in plaintext, which should be noted when writing the program. I have tried several well-known domestic websites,
js|server|sqlserver| Data | Database JSP connection All kinds of databases Daquan SQLServer2000 JDBC driver Complete installation and test instructions
SQLServer2000 JDBC Driver Complete installation and test instructions (reprint)
First, download
Web
first, using the Microsoft JDBC Driver
1 to www.microsoft.com download "Microsoft SQL Server Driver for JDBC" and install
2 after installation, there are three jar packages in the installed
Yesterday at home to tidy my baby hard drive, found before a JSP based on the structure of the electronic trading platform source code, but also has a database, anyway, it is okay, so I want to get it, let it run. Next, download the JDBC driver that
msdb-contains information about jobs, alarms, and operators if the media containing the system database has changed, the system database must be rebuilt, and if you can still start the SQL Server service, you can recover the database from the backup
SQL2005 Unable to start SQL Server request failed or service not responding in time
Deactivate the VIA protocol to resolve the problem. Via protocol Deactivation Method: Start-> program->microsoft SQL Server 2005-> Configuration Tool->sql Server
server| problem ""microsoft SQL Server 7.0"hereinafter referred to as"sql server 7.0""
In SQL Server 7.0, how do I cycle errorlog (error log) without restarting the SQL Server service? (NEW)
In SQL Server 7.0, if you want to cycle errorlog, (that
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.